PROC APPEND might generate an "Out of memory" error message. This is most likely to occur when PROC APPEND is used to append data to a BASE= data set that is empty and has multiple indexes defined in it. Subsequent updating of the indexes might fail due to a lack of memory and can result in a damaged BASE= data set.

There are two possible workarounds for this issue.

1. Avoid the error message by adding the following OPTIONS statement just before the PROC APPEND step:

   options $debug='yoebat=1';
   

2. Create the data set and then create the indexes.

   a. Use PROC DATASETS to create the indexes following the creation of the data set:

   data test;
      do i = 1 to 100;
         x=i;
         output;
      end;
   run;
   proc datasets;
      modify test;
      index create x;
      index create i;
   run;
   quit;
   

   b. Create the indexes while also creating the data set:

   data test(index=(x i));
      do i = 1 to 100;
         x=i;
         output;
      end;
   run;
   

Operating System and Release Information